package com.example.mapper;

import com.example.entity.SpuAttrValue;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 12057
* @description 针对表【spu_attr_value(spu属性值)】的数据库操作Mapper
* @createDate 2024-05-13 13:48:02
* @Entity com.example.entity.SpuAttrValue
*/
public interface SpuAttrValueMapper extends BaseMapper<SpuAttrValue> {

    @Select("select attr_id,attr_name,attr_value from spu_attr_value where spu_id = #{spuId}")
    List<SpuAttrValue> getSpuAttrsBySpuId(@Param("spuId") Integer spuId);

    @Select("select attr_id,attr_name,attr_value from admin_spu_attr_value_exam where spu_id = #{spuId}")
    List<SpuAttrValue> getExamSpuAttrsBySpuId(@Param("spuId") Integer spuId);
}




